package com.apache.attachment.dao;

import com.apache.database.db.DaoImpl;

public class AttachmentRegisterDaoImpl extends DaoImpl {

	public String getSql(int type) {
		String sql = "";
		switch (type) {
		case 1:
			sql = "select count(*) from AttachmentRegister where 1=1 ";
			break;
		case 2:
			sql = " from AttachmentRegister where 1=1 ";
			break;
		case 3:
			sql = "select count(*) from AttachmentRegister ar where ar.regEname=:regEname";
			break;
		case 4:
			sql = "select count(*) from AttachmentRegister ar where ar.regEname=:regEname and ar.rid !=:rid";
			break;
		default:
			sql = "select count(*) from AttachmentRegister where 1=1 ";
		}
		return sql;
	}

	public void initSystemCache() {
	}
}
